package com.mustafaiev.tair.autobase.dao;

import java.sql.ResultSet;
import java.sql.SQLException;

import com.mustafaiev.tair.autobase.worker.Position;

/**
 * DAO for position entity
 * 
 * @author Tair Mustafaiev
 *
 */
public interface PositionDao {
	/**
	 * @param position
	 * @return int
	 * @throws SQLException
	 */
	int addPosition(Position position) throws SQLException;

	/**
	 * @param position
	 * @return {@link ResultSet}
	 * @throws SQLException
	 */
	ResultSet getPosition(Position position) throws SQLException;

	/**
	 * @return {@link ResultSet}
	 * @throws SQLException
	 */
	ResultSet getPositionList() throws SQLException;

	/**
	 * @param position
	 * @return int
	 * @throws SQLException
	 */
	int deletePosition(Position position) throws SQLException;

	/**
	 * @param position
	 * @return
	 * @throws SQLException
	 */
	int updatePositionInfo(Position position) throws SQLException;
}
